using System;
using System.Collections.Generic;
using System.Text;
using AF_ORM.CORE;
using System.Data;
using System.Configuration;
using Bussiness.Config;     
using Bussiness.Entity;
namespace Bussiness.ManagerBase
{
                

     public abstract class PT_ServiceBillManagerBase
    {
        public PT_ServiceBillManagerBase()
        {
            Adapter.ConnectionString =  ConnectionConfig.ConnectionString;            
        }
                    
 
        /// <summary>
        /// Them moi du lieu
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity Insert(PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity) Adapter.Insert(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo khoa chinh cua object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity Update(PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.Update(obj);             
        }
 
 
        /// <summary>
        /// Update du lieu theo dieu kien trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity UpdateWithCondition(PT_ServiceBillEntity obj,PT_ServiceBillEntity objCond)
        { 
            return (PT_ServiceBillEntity)Adapter.UpdateWithCondition(obj,objCond);             
        }
 
 
        public PT_ServiceBillEntity Delete(PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.Delete(obj);             
        }
 
 
        public PT_ServiceBillEntity DeleteWithCondition(PT_ServiceBillEntity objCond)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteWithCondition(objCond);             
        }
 


        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByAddress (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Address");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Address 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByAddress (string Address )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Address = Address;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Address");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByAddressNumber (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"AddressNumber");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien AddressNumber 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByAddressNumber (string AddressNumber )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.AddressNumber = AddressNumber;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"AddressNumber");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByBill_NO (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Bill_NO 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByBill_NO (string Bill_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Bill_NO = Bill_NO;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCashier (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Cashier");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Cashier 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCashier (int Cashier )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Cashier = Cashier;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Cashier");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCellPhone (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CellPhone");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CellPhone 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCellPhone (string CellPhone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CellPhone = CellPhone;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CellPhone");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCheckBy (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CheckBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CheckBy 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCheckBy (int CheckBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CheckBy = CheckBy;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CheckBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByComment (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Comment");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Comment 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByComment (string Comment )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Comment = Comment;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Comment");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCreatedBy (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedBy 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCreatedBy (string CreatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedBy = CreatedBy;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCreatedDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CreatedDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCreatedDate (DateTime CreatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedDate = CreatedDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustName (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustName 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustName (string CustName )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName = CustName;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustName");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustName_noUnicode (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustName_noUnicode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustName_noUnicode 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustName_noUnicode (string CustName_noUnicode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName_noUnicode = CustName_noUnicode;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustName_noUnicode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustomerRequest (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustomerRequest");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien CustomerRequest 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByCustomerRequest (string CustomerRequest )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustomerRequest = CustomerRequest;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"CustomerRequest");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByDescription (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Description");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Description 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByDescription (string Description )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Description = Description;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Description");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByDistCode (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"DistCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien DistCode 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByDistCode (int DistCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.DistCode = DistCode;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"DistCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByFinishDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"FinishDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien FinishDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByFinishDate (DateTime FinishDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.FinishDate = FinishDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"FinishDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByFuellevel (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Fuellevel");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Fuellevel 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByFuellevel (int Fuellevel )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Fuellevel = Fuellevel;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Fuellevel");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByInputDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"InputDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien InputDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByInputDate (DateTime InputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.InputDate = InputDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"InputDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsDeleted (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsDeleted 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsDeleted (bool IsDeleted )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsDeleted = IsDeleted;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsFinished (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsFinished");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsFinished 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsFinished (bool IsFinished )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsFinished = IsFinished;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsFinished");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsUseOil (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsUseOil");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien IsUseOil 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByIsUseOil (bool IsUseOil )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsUseOil = IsUseOil;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"IsUseOil");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMachineCode (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MachineCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MachineCode 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMachineCode (string MachineCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MachineCode = MachineCode;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MachineCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByModel (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Model");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Model 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByModel (string Model )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Model = Model;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Model");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMotorStatus (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MotorStatus");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MotorStatus 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMotorStatus (string MotorStatus )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatus = MotorStatus;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MotorStatus");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMotorStatusBefore (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MotorStatusBefore");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien MotorStatusBefore 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByMotorStatusBefore (string MotorStatusBefore )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatusBefore = MotorStatusBefore;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"MotorStatusBefore");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByNumberPlate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"NumberPlate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien NumberPlate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByNumberPlate (string NumberPlate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.NumberPlate = NumberPlate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"NumberPlate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOilPaid (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OilPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OilPaid 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOilPaid (double OilPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OilPaid = OilPaid;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OilPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOutPaid (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OutPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutPaid 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOutPaid (double OutPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutPaid = OutPaid;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OutPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOutputDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OutputDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien OutputDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByOutputDate (DateTime OutputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutputDate = OutputDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"OutputDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByPhone (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Phone");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Phone 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByPhone (string Phone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Phone = Phone;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Phone");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByProvinceCode (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ProvinceCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ProvinceCode 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByProvinceCode (int ProvinceCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ProvinceCode = ProvinceCode;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ProvinceCode");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByQOT_NO (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"QOT_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien QOT_NO 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByQOT_NO (string QOT_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.QOT_NO = QOT_NO;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"QOT_NO");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByReceivedBy (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ReceivedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ReceivedBy 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByReceivedBy (int ReceivedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReceivedBy = ReceivedBy;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ReceivedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairDate (DateTime RepairDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairDate = RepairDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairedBy (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairedBy 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairedBy (int RepairedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy = RepairedBy;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairedBy2 (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairedBy2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairedBy2 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairedBy2 (int RepairedBy2 )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy2 = RepairedBy2;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairedBy2");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairPaid (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien RepairPaid 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByRepairPaid (double RepairPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairPaid = RepairPaid;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"RepairPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByReportDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ReportDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ReportDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByReportDate (DateTime ReportDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReportDate = ReportDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ReportDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteBySBH (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"SBH");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien SBH 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteBySBH (string SBH )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.SBH = SBH;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"SBH");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByServicePaid (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ServicePaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServicePaid 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByServicePaid (double ServicePaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServicePaid = ServicePaid;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ServicePaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByServiceType (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ServiceType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ServiceType 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByServiceType (string ServiceType )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServiceType = ServiceType;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ServiceType");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByToolPaid (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ToolPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien ToolPaid 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByToolPaid (double ToolPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ToolPaid = ToolPaid;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"ToolPaid");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalKms (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalKms");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalKms 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalKms (double TotalKms )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalKms = TotalKms;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalKms");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalLaiGCN (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalLaiGCN");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalLaiGCN 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalLaiGCN (double TotalLaiGCN )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiGCN = TotalLaiGCN;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalLaiGCN");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalLaiPTTM (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalLaiPTTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalLaiPTTM 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalLaiPTTM (double TotalLaiPTTM )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiPTTM = TotalLaiPTTM;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalLaiPTTM");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalMoney (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalMoney");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien TotalMoney 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByTotalMoney (double TotalMoney )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalMoney = TotalMoney;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"TotalMoney");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByUpdatedBy (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedBy 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByUpdatedBy (string UpdatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByUpdatedDate (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien UpdatedDate 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByWard (PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Ward");
        }

        /// <summary>
        /// Xoa cac dong du lieu thoa dieu kien Ward 
        /// </summary>
        /// <returns>PT_ServiceBillEntity</returns>
        public PT_ServiceBillEntity DeleteByWard (string Ward )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Ward = Ward;  
            return (PT_ServiceBillEntity)Adapter.DeleteByField(obj,"Ward");
        }

 
        /// <summary>
        /// Lay du lieu theo khoa chinh object
        /// </summary>
        /// <returns></returns>
        public PT_ServiceBillEntity Select(PT_ServiceBillEntity obj)
        { 
            return (PT_ServiceBillEntity) Adapter.Select(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ServiceBillEntity obj)
        { 
            return  Adapter.SelectWithCondition(obj);             
        }
 
 
        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns></returns>
        public DataTable SelectWithCondition(PT_ServiceBillEntity obj,SelectOptions option)
        {             
            return  Adapter.SelectWithCondition(obj,option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll()
        { 
            return Adapter.SelectAll(new PT_ServiceBillEntity());             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAll(SelectOptions option)
        { 
            return Adapter.SelectAll(new PT_ServiceBillEntity(),option);             
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ServiceBillEntity> SelectAllLST()
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ServiceBillEntity()),new PT_ServiceBillEntity());           
        }
 
 
        /// <summary>
        /// Lay tat ca cac du lieu trong table
        /// </summary>
        /// <returns></returns>
        public List<PT_ServiceBillEntity> SelectAllLST(SelectOptions option)
        { 
            return (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectAll(new PT_ServiceBillEntity(),option),new PT_ServiceBillEntity());             
        }
 

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Address");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Address",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByAddressLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByAddressLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Address",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (string Address )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Address = Address;  
            return Adapter.SelectByField(obj,"Address");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddress (string Address, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Address = Address;  
            return Adapter.SelectByField(obj,"Address",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByAddressLST (string Address )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Address = Address;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Address duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByAddressLST (string Address, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Address = Address;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Address",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressNumber (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"AddressNumber");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressNumber (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"AddressNumber",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByAddressNumberLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressNumber"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByAddressNumberLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"AddressNumber",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressNumber (string AddressNumber )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.AddressNumber = AddressNumber;  
            return Adapter.SelectByField(obj,"AddressNumber");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByAddressNumber (string AddressNumber, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.AddressNumber = AddressNumber;  
            return Adapter.SelectByField(obj,"AddressNumber",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByAddressNumberLST (string AddressNumber )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.AddressNumber = AddressNumber;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressNumber"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien AddressNumber duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByAddressNumberLST (string AddressNumber, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.AddressNumber = AddressNumber;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"AddressNumber",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Bill_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByBill_NOLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByBill_NOLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Bill_NO",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (string Bill_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Bill_NO = Bill_NO;  
            return Adapter.SelectByField(obj,"Bill_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByBill_NO (string Bill_NO, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Bill_NO = Bill_NO;  
            return Adapter.SelectByField(obj,"Bill_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByBill_NOLST (string Bill_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Bill_NO = Bill_NO;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Bill_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByBill_NOLST (string Bill_NO, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Bill_NO = Bill_NO;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Bill_NO",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCashier (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Cashier");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCashier (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Cashier",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCashierLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cashier"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCashierLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Cashier",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCashier (int Cashier )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Cashier = Cashier;  
            return Adapter.SelectByField(obj,"Cashier");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCashier (int Cashier, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Cashier = Cashier;  
            return Adapter.SelectByField(obj,"Cashier",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCashierLST (int Cashier )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Cashier = Cashier;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cashier"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Cashier duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCashierLST (int Cashier, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Cashier = Cashier;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Cashier",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCellPhone (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CellPhone");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCellPhone (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CellPhone",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCellPhoneLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CellPhone"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCellPhoneLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CellPhone",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCellPhone (string CellPhone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CellPhone = CellPhone;  
            return Adapter.SelectByField(obj,"CellPhone");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCellPhone (string CellPhone, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CellPhone = CellPhone;  
            return Adapter.SelectByField(obj,"CellPhone",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCellPhoneLST (string CellPhone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CellPhone = CellPhone;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CellPhone"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CellPhone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCellPhoneLST (string CellPhone, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CellPhone = CellPhone;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CellPhone",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCheckBy (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CheckBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCheckBy (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CheckBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCheckByLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CheckBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCheckByLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CheckBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCheckBy (int CheckBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CheckBy = CheckBy;  
            return Adapter.SelectByField(obj,"CheckBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCheckBy (int CheckBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CheckBy = CheckBy;  
            return Adapter.SelectByField(obj,"CheckBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCheckByLST (int CheckBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CheckBy = CheckBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CheckBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CheckBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCheckByLST (int CheckBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CheckBy = CheckBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CheckBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Comment");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Comment",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCommentLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCommentLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Comment",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (string Comment )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Comment = Comment;  
            return Adapter.SelectByField(obj,"Comment");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByComment (string Comment, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Comment = Comment;  
            return Adapter.SelectByField(obj,"Comment",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCommentLST (string Comment )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Comment = Comment;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Comment duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCommentLST (string Comment, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Comment = Comment;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Comment",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCreatedByLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCreatedByLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedBy (string CreatedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedBy = CreatedBy;  
            return Adapter.SelectByField(obj,"CreatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCreatedByLST (string CreatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCreatedByLST (string CreatedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedBy = CreatedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCreatedDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCreatedDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CreatedDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCreatedDate (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedDate = CreatedDate;  
            return Adapter.SelectByField(obj,"CreatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCreatedDateLST (DateTime CreatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CreatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCreatedDateLST (DateTime CreatedDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CreatedDate = CreatedDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CreatedDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CustName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CustName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustNameLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustNameLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CustName",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName (string CustName )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName = CustName;  
            return Adapter.SelectByField(obj,"CustName");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName (string CustName, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName = CustName;  
            return Adapter.SelectByField(obj,"CustName",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustNameLST (string CustName )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName = CustName;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustNameLST (string CustName, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName = CustName;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName_noUnicode (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CustName_noUnicode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName_noUnicode (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CustName_noUnicode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustName_noUnicodeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName_noUnicode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustName_noUnicodeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CustName_noUnicode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName_noUnicode (string CustName_noUnicode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName_noUnicode = CustName_noUnicode;  
            return Adapter.SelectByField(obj,"CustName_noUnicode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustName_noUnicode (string CustName_noUnicode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName_noUnicode = CustName_noUnicode;  
            return Adapter.SelectByField(obj,"CustName_noUnicode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustName_noUnicodeLST (string CustName_noUnicode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName_noUnicode = CustName_noUnicode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName_noUnicode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustName_noUnicode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustName_noUnicodeLST (string CustName_noUnicode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustName_noUnicode = CustName_noUnicode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustName_noUnicode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustomerRequest (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"CustomerRequest");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustomerRequest (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"CustomerRequest",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustomerRequestLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustomerRequest"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByCustomerRequestLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"CustomerRequest",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustomerRequest (string CustomerRequest )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustomerRequest = CustomerRequest;  
            return Adapter.SelectByField(obj,"CustomerRequest");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByCustomerRequest (string CustomerRequest, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustomerRequest = CustomerRequest;  
            return Adapter.SelectByField(obj,"CustomerRequest",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustomerRequestLST (string CustomerRequest )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustomerRequest = CustomerRequest;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustomerRequest"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien CustomerRequest duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByCustomerRequestLST (string CustomerRequest, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.CustomerRequest = CustomerRequest;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"CustomerRequest",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDescription (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Description");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDescription (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Description",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByDescriptionLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Description"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByDescriptionLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Description",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDescription (string Description )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Description = Description;  
            return Adapter.SelectByField(obj,"Description");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDescription (string Description, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Description = Description;  
            return Adapter.SelectByField(obj,"Description",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByDescriptionLST (string Description )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Description = Description;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Description"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Description duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByDescriptionLST (string Description, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Description = Description;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Description",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDistCode (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"DistCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDistCode (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"DistCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByDistCodeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DistCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByDistCodeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"DistCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDistCode (int DistCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.DistCode = DistCode;  
            return Adapter.SelectByField(obj,"DistCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByDistCode (int DistCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.DistCode = DistCode;  
            return Adapter.SelectByField(obj,"DistCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByDistCodeLST (int DistCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.DistCode = DistCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DistCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien DistCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByDistCodeLST (int DistCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.DistCode = DistCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"DistCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFinishDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"FinishDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFinishDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"FinishDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByFinishDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FinishDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByFinishDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"FinishDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFinishDate (DateTime FinishDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.FinishDate = FinishDate;  
            return Adapter.SelectByField(obj,"FinishDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFinishDate (DateTime FinishDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.FinishDate = FinishDate;  
            return Adapter.SelectByField(obj,"FinishDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByFinishDateLST (DateTime FinishDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.FinishDate = FinishDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FinishDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien FinishDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByFinishDateLST (DateTime FinishDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.FinishDate = FinishDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"FinishDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFuellevel (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Fuellevel");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFuellevel (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Fuellevel",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByFuellevelLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Fuellevel"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByFuellevelLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Fuellevel",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFuellevel (int Fuellevel )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Fuellevel = Fuellevel;  
            return Adapter.SelectByField(obj,"Fuellevel");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByFuellevel (int Fuellevel, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Fuellevel = Fuellevel;  
            return Adapter.SelectByField(obj,"Fuellevel",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByFuellevelLST (int Fuellevel )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Fuellevel = Fuellevel;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Fuellevel"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Fuellevel duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByFuellevelLST (int Fuellevel, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Fuellevel = Fuellevel;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Fuellevel",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInputDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"InputDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInputDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"InputDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByInputDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"InputDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByInputDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"InputDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInputDate (DateTime InputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.InputDate = InputDate;  
            return Adapter.SelectByField(obj,"InputDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByInputDate (DateTime InputDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.InputDate = InputDate;  
            return Adapter.SelectByField(obj,"InputDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByInputDateLST (DateTime InputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.InputDate = InputDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"InputDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien InputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByInputDateLST (DateTime InputDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.InputDate = InputDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"InputDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsDeletedLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsDeletedLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsDeleted",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsDeleted (bool IsDeleted, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsDeleted = IsDeleted;  
            return Adapter.SelectByField(obj,"IsDeleted",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsDeletedLST (bool IsDeleted )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsDeleted duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsDeletedLST (bool IsDeleted, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsDeleted = IsDeleted;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsDeleted",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsFinished (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsFinished");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsFinished (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsFinished",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsFinishedLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsFinished"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsFinishedLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsFinished",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsFinished (bool IsFinished )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsFinished = IsFinished;  
            return Adapter.SelectByField(obj,"IsFinished");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsFinished (bool IsFinished, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsFinished = IsFinished;  
            return Adapter.SelectByField(obj,"IsFinished",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsFinishedLST (bool IsFinished )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsFinished = IsFinished;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsFinished"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsFinished duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsFinishedLST (bool IsFinished, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsFinished = IsFinished;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsFinished",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsUseOil (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"IsUseOil");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsUseOil (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"IsUseOil",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsUseOilLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsUseOil"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByIsUseOilLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"IsUseOil",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsUseOil (bool IsUseOil )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsUseOil = IsUseOil;  
            return Adapter.SelectByField(obj,"IsUseOil");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByIsUseOil (bool IsUseOil, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsUseOil = IsUseOil;  
            return Adapter.SelectByField(obj,"IsUseOil",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsUseOilLST (bool IsUseOil )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsUseOil = IsUseOil;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsUseOil"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien IsUseOil duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByIsUseOilLST (bool IsUseOil, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.IsUseOil = IsUseOil;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"IsUseOil",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMachineCode (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"MachineCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMachineCode (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MachineCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMachineCodeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MachineCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMachineCodeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MachineCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMachineCode (string MachineCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MachineCode = MachineCode;  
            return Adapter.SelectByField(obj,"MachineCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMachineCode (string MachineCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MachineCode = MachineCode;  
            return Adapter.SelectByField(obj,"MachineCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMachineCodeLST (string MachineCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MachineCode = MachineCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MachineCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MachineCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMachineCodeLST (string MachineCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MachineCode = MachineCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MachineCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByModel (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Model");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByModel (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Model",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByModelLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Model"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByModelLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Model",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByModel (string Model )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Model = Model;  
            return Adapter.SelectByField(obj,"Model");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByModel (string Model, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Model = Model;  
            return Adapter.SelectByField(obj,"Model",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByModelLST (string Model )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Model = Model;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Model"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Model duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByModelLST (string Model, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Model = Model;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Model",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatus (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"MotorStatus");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatus (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MotorStatus",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatus"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MotorStatus",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatus (string MotorStatus )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatus = MotorStatus;  
            return Adapter.SelectByField(obj,"MotorStatus");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatus (string MotorStatus, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatus = MotorStatus;  
            return Adapter.SelectByField(obj,"MotorStatus",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusLST (string MotorStatus )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatus = MotorStatus;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatus"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatus duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusLST (string MotorStatus, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatus = MotorStatus;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatus",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatusBefore (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"MotorStatusBefore");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatusBefore (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"MotorStatusBefore",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusBeforeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatusBefore"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusBeforeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"MotorStatusBefore",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatusBefore (string MotorStatusBefore )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatusBefore = MotorStatusBefore;  
            return Adapter.SelectByField(obj,"MotorStatusBefore");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByMotorStatusBefore (string MotorStatusBefore, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatusBefore = MotorStatusBefore;  
            return Adapter.SelectByField(obj,"MotorStatusBefore",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusBeforeLST (string MotorStatusBefore )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatusBefore = MotorStatusBefore;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatusBefore"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien MotorStatusBefore duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByMotorStatusBeforeLST (string MotorStatusBefore, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.MotorStatusBefore = MotorStatusBefore;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"MotorStatusBefore",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByNumberPlate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"NumberPlate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByNumberPlate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"NumberPlate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByNumberPlateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"NumberPlate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByNumberPlateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"NumberPlate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByNumberPlate (string NumberPlate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.NumberPlate = NumberPlate;  
            return Adapter.SelectByField(obj,"NumberPlate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByNumberPlate (string NumberPlate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.NumberPlate = NumberPlate;  
            return Adapter.SelectByField(obj,"NumberPlate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByNumberPlateLST (string NumberPlate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.NumberPlate = NumberPlate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"NumberPlate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien NumberPlate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByNumberPlateLST (string NumberPlate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.NumberPlate = NumberPlate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"NumberPlate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOilPaid (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"OilPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOilPaid (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"OilPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOilPaidLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OilPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOilPaidLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"OilPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOilPaid (double OilPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OilPaid = OilPaid;  
            return Adapter.SelectByField(obj,"OilPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOilPaid (double OilPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OilPaid = OilPaid;  
            return Adapter.SelectByField(obj,"OilPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOilPaidLST (double OilPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OilPaid = OilPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OilPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OilPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOilPaidLST (double OilPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OilPaid = OilPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OilPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"OutPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"OutPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOutPaidLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOutPaidLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"OutPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (double OutPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutPaid = OutPaid;  
            return Adapter.SelectByField(obj,"OutPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutPaid (double OutPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutPaid = OutPaid;  
            return Adapter.SelectByField(obj,"OutPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOutPaidLST (double OutPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutPaid = OutPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOutPaidLST (double OutPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutPaid = OutPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutputDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"OutputDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutputDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"OutputDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOutputDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutputDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByOutputDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"OutputDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutputDate (DateTime OutputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutputDate = OutputDate;  
            return Adapter.SelectByField(obj,"OutputDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByOutputDate (DateTime OutputDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutputDate = OutputDate;  
            return Adapter.SelectByField(obj,"OutputDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOutputDateLST (DateTime OutputDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutputDate = OutputDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutputDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien OutputDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByOutputDateLST (DateTime OutputDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.OutputDate = OutputDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"OutputDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhone (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Phone");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhone (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Phone",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByPhoneLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Phone"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByPhoneLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Phone",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhone (string Phone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Phone = Phone;  
            return Adapter.SelectByField(obj,"Phone");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByPhone (string Phone, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Phone = Phone;  
            return Adapter.SelectByField(obj,"Phone",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByPhoneLST (string Phone )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Phone = Phone;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Phone"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Phone duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByPhoneLST (string Phone, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Phone = Phone;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Phone",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProvinceCode (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ProvinceCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProvinceCode (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ProvinceCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByProvinceCodeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProvinceCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByProvinceCodeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ProvinceCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProvinceCode (int ProvinceCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ProvinceCode = ProvinceCode;  
            return Adapter.SelectByField(obj,"ProvinceCode");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByProvinceCode (int ProvinceCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ProvinceCode = ProvinceCode;  
            return Adapter.SelectByField(obj,"ProvinceCode",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByProvinceCodeLST (int ProvinceCode )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ProvinceCode = ProvinceCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProvinceCode"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ProvinceCode duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByProvinceCodeLST (int ProvinceCode, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ProvinceCode = ProvinceCode;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ProvinceCode",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQOT_NO (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"QOT_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQOT_NO (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"QOT_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByQOT_NOLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QOT_NO"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByQOT_NOLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"QOT_NO",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQOT_NO (string QOT_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.QOT_NO = QOT_NO;  
            return Adapter.SelectByField(obj,"QOT_NO");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByQOT_NO (string QOT_NO, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.QOT_NO = QOT_NO;  
            return Adapter.SelectByField(obj,"QOT_NO",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByQOT_NOLST (string QOT_NO )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.QOT_NO = QOT_NO;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QOT_NO"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien QOT_NO duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByQOT_NOLST (string QOT_NO, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.QOT_NO = QOT_NO;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"QOT_NO",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReceivedBy (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ReceivedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReceivedBy (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ReceivedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByReceivedByLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReceivedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByReceivedByLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ReceivedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReceivedBy (int ReceivedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReceivedBy = ReceivedBy;  
            return Adapter.SelectByField(obj,"ReceivedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReceivedBy (int ReceivedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReceivedBy = ReceivedBy;  
            return Adapter.SelectByField(obj,"ReceivedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByReceivedByLST (int ReceivedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReceivedBy = ReceivedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReceivedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReceivedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByReceivedByLST (int ReceivedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReceivedBy = ReceivedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReceivedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"RepairDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RepairDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RepairDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairDate (DateTime RepairDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairDate = RepairDate;  
            return Adapter.SelectByField(obj,"RepairDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairDate (DateTime RepairDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairDate = RepairDate;  
            return Adapter.SelectByField(obj,"RepairDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairDateLST (DateTime RepairDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairDate = RepairDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairDateLST (DateTime RepairDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairDate = RepairDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"RepairedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RepairedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairedByLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairedByLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RepairedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy (int RepairedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy = RepairedBy;  
            return Adapter.SelectByField(obj,"RepairedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy (int RepairedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy = RepairedBy;  
            return Adapter.SelectByField(obj,"RepairedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairedByLST (int RepairedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy = RepairedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairedByLST (int RepairedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy = RepairedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy2 (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"RepairedBy2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy2 (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RepairedBy2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairedBy2LST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy2"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairedBy2LST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RepairedBy2",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy2 (int RepairedBy2 )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy2 = RepairedBy2;  
            return Adapter.SelectByField(obj,"RepairedBy2");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairedBy2 (int RepairedBy2, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy2 = RepairedBy2;  
            return Adapter.SelectByField(obj,"RepairedBy2",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairedBy2LST (int RepairedBy2 )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy2 = RepairedBy2;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy2"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairedBy2 duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairedBy2LST (int RepairedBy2, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairedBy2 = RepairedBy2;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairedBy2",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairPaid (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"RepairPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairPaid (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"RepairPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairPaidLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByRepairPaidLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"RepairPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairPaid (double RepairPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairPaid = RepairPaid;  
            return Adapter.SelectByField(obj,"RepairPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByRepairPaid (double RepairPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairPaid = RepairPaid;  
            return Adapter.SelectByField(obj,"RepairPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairPaidLST (double RepairPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairPaid = RepairPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien RepairPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByRepairPaidLST (double RepairPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.RepairPaid = RepairPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"RepairPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReportDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ReportDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReportDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ReportDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByReportDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReportDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByReportDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ReportDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReportDate (DateTime ReportDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReportDate = ReportDate;  
            return Adapter.SelectByField(obj,"ReportDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByReportDate (DateTime ReportDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReportDate = ReportDate;  
            return Adapter.SelectByField(obj,"ReportDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByReportDateLST (DateTime ReportDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReportDate = ReportDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReportDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ReportDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByReportDateLST (DateTime ReportDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ReportDate = ReportDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ReportDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySBH (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"SBH");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySBH (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"SBH",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectBySBHLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SBH"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectBySBHLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"SBH",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySBH (string SBH )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.SBH = SBH;  
            return Adapter.SelectByField(obj,"SBH");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectBySBH (string SBH, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.SBH = SBH;  
            return Adapter.SelectByField(obj,"SBH",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectBySBHLST (string SBH )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.SBH = SBH;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SBH"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien SBH duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectBySBHLST (string SBH, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.SBH = SBH;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"SBH",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServicePaid (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ServicePaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServicePaid (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ServicePaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByServicePaidLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServicePaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByServicePaidLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ServicePaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServicePaid (double ServicePaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServicePaid = ServicePaid;  
            return Adapter.SelectByField(obj,"ServicePaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServicePaid (double ServicePaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServicePaid = ServicePaid;  
            return Adapter.SelectByField(obj,"ServicePaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByServicePaidLST (double ServicePaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServicePaid = ServicePaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServicePaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServicePaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByServicePaidLST (double ServicePaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServicePaid = ServicePaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServicePaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ServiceType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ServiceType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByServiceTypeLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByServiceTypeLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ServiceType",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (string ServiceType )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServiceType = ServiceType;  
            return Adapter.SelectByField(obj,"ServiceType");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByServiceType (string ServiceType, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServiceType = ServiceType;  
            return Adapter.SelectByField(obj,"ServiceType",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByServiceTypeLST (string ServiceType )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServiceType = ServiceType;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ServiceType duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByServiceTypeLST (string ServiceType, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ServiceType = ServiceType;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ServiceType",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolPaid (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"ToolPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolPaid (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"ToolPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByToolPaidLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByToolPaidLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"ToolPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolPaid (double ToolPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ToolPaid = ToolPaid;  
            return Adapter.SelectByField(obj,"ToolPaid");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByToolPaid (double ToolPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ToolPaid = ToolPaid;  
            return Adapter.SelectByField(obj,"ToolPaid",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByToolPaidLST (double ToolPaid )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ToolPaid = ToolPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolPaid"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien ToolPaid duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByToolPaidLST (double ToolPaid, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.ToolPaid = ToolPaid;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"ToolPaid",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalKms (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"TotalKms");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalKms (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TotalKms",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalKmsLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalKms"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalKmsLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TotalKms",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalKms (double TotalKms )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalKms = TotalKms;  
            return Adapter.SelectByField(obj,"TotalKms");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalKms (double TotalKms, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalKms = TotalKms;  
            return Adapter.SelectByField(obj,"TotalKms",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalKmsLST (double TotalKms )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalKms = TotalKms;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalKms"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalKms duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalKmsLST (double TotalKms, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalKms = TotalKms;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalKms",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiGCN (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"TotalLaiGCN");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiGCN (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TotalLaiGCN",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiGCNLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiGCN"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiGCNLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TotalLaiGCN",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiGCN (double TotalLaiGCN )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiGCN = TotalLaiGCN;  
            return Adapter.SelectByField(obj,"TotalLaiGCN");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiGCN (double TotalLaiGCN, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiGCN = TotalLaiGCN;  
            return Adapter.SelectByField(obj,"TotalLaiGCN",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiGCNLST (double TotalLaiGCN )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiGCN = TotalLaiGCN;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiGCN"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiGCN duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiGCNLST (double TotalLaiGCN, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiGCN = TotalLaiGCN;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiGCN",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiPTTM (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"TotalLaiPTTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiPTTM (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TotalLaiPTTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiPTTMLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiPTTM"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiPTTMLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TotalLaiPTTM",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiPTTM (double TotalLaiPTTM )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiPTTM = TotalLaiPTTM;  
            return Adapter.SelectByField(obj,"TotalLaiPTTM");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalLaiPTTM (double TotalLaiPTTM, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiPTTM = TotalLaiPTTM;  
            return Adapter.SelectByField(obj,"TotalLaiPTTM",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiPTTMLST (double TotalLaiPTTM )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiPTTM = TotalLaiPTTM;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiPTTM"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalLaiPTTM duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalLaiPTTMLST (double TotalLaiPTTM, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalLaiPTTM = TotalLaiPTTM;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalLaiPTTM",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalMoney (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"TotalMoney");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalMoney (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"TotalMoney",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalMoneyLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalMoney"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByTotalMoneyLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"TotalMoney",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalMoney (double TotalMoney )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalMoney = TotalMoney;  
            return Adapter.SelectByField(obj,"TotalMoney");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByTotalMoney (double TotalMoney, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalMoney = TotalMoney;  
            return Adapter.SelectByField(obj,"TotalMoney",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalMoneyLST (double TotalMoney )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalMoney = TotalMoney;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalMoney"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien TotalMoney duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByTotalMoneyLST (double TotalMoney, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.TotalMoney = TotalMoney;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"TotalMoney",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedByLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedByLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedBy (string UpdatedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return Adapter.SelectByField(obj,"UpdatedBy",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedByLST (string UpdatedBy )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedBy duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedByLST (string UpdatedBy, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedBy = UpdatedBy;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedBy",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedDateLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedDateLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByUpdatedDate (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return Adapter.SelectByField(obj,"UpdatedDate",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedDateLST (DateTime UpdatedDate )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien UpdatedDate duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByUpdatedDateLST (DateTime UpdatedDate, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.UpdatedDate = UpdatedDate;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"UpdatedDate",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWard (PT_ServiceBillEntity obj)
        { 
            return Adapter.SelectByField(obj,"Ward");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWard (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return Adapter.SelectByField(obj,"Ward",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByWardLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Ward"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectByWardLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectByField(obj,"Ward",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward 
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWard (string Ward )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Ward = Ward;  
            return Adapter.SelectByField(obj,"Ward");
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public DataTable SelectByWard (string Ward, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Ward = Ward;  
            return Adapter.SelectByField(obj,"Ward",option);
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward 
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByWardLST (string Ward )
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Ward = Ward;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Ward"),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien Ward duoc set trong object
        /// </summary>
        /// <returns>DataTable</returns>
        public List<PT_ServiceBillEntity> SelectByWardLST (string Ward, SelectOptions option)
        { 
            PT_ServiceBillEntity obj = new PT_ServiceBillEntity();
            obj.Ward = Ward;  
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList(Adapter.SelectByField(obj,"Ward",option),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectWithConditionLST (PT_ServiceBillEntity obj)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj),new PT_ServiceBillEntity());
        }

        /// <summary>
        /// Lay du lieu theo cac dieu kien duoc set trong object
        /// </summary>
        /// <returns>List<PT_ServiceBillEntity></returns>
        public List<PT_ServiceBillEntity> SelectWithConditionLST (PT_ServiceBillEntity obj,SelectOptions option)
        { 
            return  (List<PT_ServiceBillEntity>) EntityUtil.CopyDataTableToEntityList( Adapter.SelectWithCondition(obj,option),new PT_ServiceBillEntity());
        }

}
}
